The UK's best city for tourists has been named, and it's not major players London or Manchester. However, it is a stunningly historic spot.