A £230M investment in water treatment is needed due to 'new housing developments and the local population continuing to grow'