Roman water pipes ended up covered in (substance I don't recall the name of), and so not much lead leeched into the water. Water jugs made of lead were probably more of a problem.

The same holds true for modern lead pipes. They work fine, until they don't.