Young and low paid workers in tourist hotspots are increasingly being priced out of homes, new analysis has shown.