"This was an exceptionally long time and it emphasises that effort is needed to fix the problem," Mr Cadogan said yesterday.
Last month, he said the council would upgrade the area's water by July next year.
It had looked for solutions for a long time, but had difficulty in finding a location for a new bore. If a new source could not be found, better water treatment would be required at a higher cost.