Overhauling water tariffs could help struggling families, the Consumer Council for Water says.