What about faucets?

Lead is used in brass for corrosion resistance even in handling drinkable water. It does not markedly leach into the water and increases the usability of the plumbing from less than 5 years to more than 30 years.

Gas welding the material results in lead fumes. There is a big quarrel about the usage of lead in water pipe connector brass parts going on in the EU.

Lead was banned in a few specific products like paint.

You can still find it all over the place in things like cabinet pulls, door handles, and even ceramic tile.