Households that waste water will be hit with fines of up to €500 after new excessive use charges were approved.