Residents in a housing estate with excessive lead levels in their water supply have been advised by a local authority not to drink the water.