Warning over the future cost of water as the deadline for councils to deliver their water plans looms.