Thousands of households are facing a further two years of having to boil their tap water before safely using it.