Yes, there was water on Arrakis in 'Children of Dune.' After Paul became the emperor, he began transforming Arrakis, and soon, the planet got water on the surface.