Council to carry out water upgrades