Three major treatment plants which provide water to more than half a million people need to be modernised to secure supplies, environmental experts have warned.