Cool Britannia’s northern capital has transformed itself from a gritty industrial city into a trendy cultural and gourmet getaway.