Mancunian Cathy Toogood selects the best hotels in this happening city, for budgets big and small