An exhibition that spans architecture, film and photography addresses the question: 'What is it to be northern?'