While Brits enjoy the last dregs of the summer holiday season, the residents of our most loved destinations are reeling from the influx of tourists.