Tom Otley takes in the excellent exhibitions and historic corners of the northern powerhouse.