Manchester’s £365m arena Co-op Live may have had an inauspicious start, with power failures, cancelled gigs and a resigning boss but, asks Laura Barton, is the glitzy new venue’s arrival a sign that the North is finally challenging the South when it comes to arts and culture?