Dwr Cymru has been slammed by a Conwy councillor who warned people "could have died" after thousands were left without water.