Solutions for sustainable water supply in booming holiday regions