About Romans, they intentionally put lead in wine for the taste, I am not sure if they also used lead pipes or cups.
https://www.quora.com/Did-Roman-Byzantine-plumbing-extend-to...
The inner surface of the pipes soon form a sort of lining that is normally not dangerous/poisoining.
The amount of lead now admissable in EU is 10 micrograms per liter, but - at least here (Italy) - until 2013 was 25 micrograms per liter.
Usually only in some particular cases (acidic waters and "stagnation" in the pipes) some relevant amounts of lead are transferred to the water.
Drinking or eating from polished lead tableware is another thing.