Seventeen kilometres of mains water pipes are to be replaced in areas of Co Cork where supply breakages have dogged communities for years.