With its impressive nightlife and ever-evolving food scene, the ‘capital of the North’ is unmatched as a UK city break. Carrie-Ann Lightly shares her insider guide for visitors with accessibility needs