Families are warned they will have to stop using tap water on the garden and take shorter showers as climate change threatens more droughts