Scotland's most visitor-friendly city attracts tourists all year-round, and with good reason: its narrow streets and grand buildings combine to make it perhaps the most handsome city in the UK.