Problems arose on October 6 with turbidity in the water, which can occur after heavy rainfall, and make the water cloudy.
Householders were advised not to drink the water or to use it for the preparation of food, or for brushing their teeth.
Irish Water says that the notice has now been lifted after a new water source and borehole was identified and tested by the Health Service Executive.
Customers in the area can now resume normal use of their water for drinking, food preparation and brushing teeth.
"We would like to thank the people of Rathkeale, local businesses and elected representatives for their patience and support while this work was carried out, and acknowledge the inconvenience they experienced as a result of this issue.
"I would also like to pay tribute to all the staff who worked tirelessly over the past two weeks to resolve this issue," said Ian O'Mahony of Irish Water.