I used 3/4 inch pipe. You can drill and thread holes for the nipples, but drilling and sealing with epoxy is faster and less likely to leak. Then, I attached a hose to a spigot on a jerry can, but any container would work.
My drinkers don't leak, but the birds are messy and the litter under the drinkers is getting too wet. This may be because my water pressure is too high. I've been reading that a pressure regulator is recommended to keep the pressure to about 1/4 psi, but I can't find it locally in Uganda and won't be around long enough to justify ordering one. You get about 1 psi if the water if your tank rises to about 2 ft above the nipples. Managing the pressure by keeping the water level below 6 inches wouldn't be practical for me.
Maybe the cups are a better idea because they don't have the same pressure restrictions. If more water comes out than the bird an drink, it goes in the cup. But regardless of what you use, you don't need to spend a fortune on large diameter PVC pipe. A length of 3/4 inch pipe, a hose, a tank, and maybe a pressure regulator, plus the nipples/cups should be all you need.