James,
To answer your initial question, they do make a PVC cement that bonds in water. I can't recall its exact name but it is a deep blue color.