The Victorian-era water treatment plant which supplies water to 70% of Cork city’s population is to undergo a €40m upgrade.