From its dynamic arts scene to its burgeoning food culture, this northern powerhouse is reshaping what it means to be cool in Britain.