People have had to drill their own boreholes, dig wells and buy from vendors, because local government has failed to provide a secure supply