When you think of dream holiday destinations, you might picture exotic trips to far-flung islands in the Maldives or the Caribbean.