It may seem like cheating a bit, but a simple way of getting this done is simply to create an epic spell which will do just this... There's precedent for something like this in the freaking Forgotten Realms, albeit in an online article at wizards.com I can't recall where. It was about some lost city of Psions and/or Elans, I think. Ahh, yes. It those who died became a Psionic Vestige. Aw well.
And well, not really about the spell Create Water, but yeah...