A family has been warned not to drink from a mains water supply after tests showed excessive levels of chemical lead.