The long-running saga of a very substandard water supply to a rural community in Co Cork seems finally to be coming to an end.