I've purchased the nipples but that's as far as I am right now. LOL. I'm okay with trying the 1 inch Sch 40 PVC with the nipples. It's really the tank that's giving me issue. I can find a 2 ft length of 4 inch Sch 40 online via TrueValue for $10. I might just have to order that and hope for the best when it comes to slipping in the valve, hoping it fits.
Thanks everyone for your tips and tricks! I really need to get this thing built. I really have a hard time remembering to water my girls. As much as I'd like to just buy that "other fountain", I'm not keen on spending $100 to get said fountain...made from PVC.