It's visited by millions of people each year and recognised as the perfect city for a night out ...