Councils are running out of time to decide the future model of their water services, which need tens of billions of dollars of investment over the coming decades.