One councillor said it was “beyond belief” that water supply issues are not being taken as “seriously as they need to be”