Local authorities in Cork, Kerry and Clare have been ordered to quickly replace almost 5,000 metres of lead piping after high levels of lead were found in their water.