A boil water notice was issued in a small Waterford town after slurry was detected in the drinking water supply.