Will I have to pay for the water I use at home as well as the infrastructure that gets it there?

Nothing changes for households. However, you will face a lower rates bill because councils will be able to charge commercial water users and polluters to clean up fresh water.