City is no longer a favourite destination, survey shows, with travellers from across the border preferring to head to Japan and France instead