Shades of Eternity
Legend
man I can see the equivelent of Cyst Pigs. 
and after tomb of annihiliation. what if magical food has ...side effects.
and after tomb of annihiliation. what if magical food has ...side effects.
The Decanter of Endless Water powering a turbine seems like an obvious choice.
Or just summon anything to turn a turbine, for that matter. Presto! Endless electricity.
in terms of areas with no water, absolutely. In terms of clean, it comes down to if salt water counts as poisoned, diseased water for purify food and drink purposes.The Decanter providing clean drinking water where there is none is perhaps even more powerful
If it does any 1st level cleric could easily provide 20k gallons of fresh water a day with a couple hours worth of effort.
But if you don’t count that, than yeah the decantur becomes even more valuable
Its a ritual. 20k gallons is a meer 5 castings or ~51 minutes of casting time. Very easy and manageable, if you want to go hard core with it you can scale it much more aggressively.So, I'm not sure where you get 20K gallons a day. More like 7800 gallons.
So, a casting of Purify Food and Drink gets a 5' radius sphere. That's 523.6 cubic feet, or 3,917 gallons. That is assuming you make a 5' radius tank spherical tank, so you get that full volume. You also need a water source, and a way to fill and empty that tank, over the course of a few hours.
With 5 castings you get 19585 gallons. It is a first level spell. A first level cleric gets two 1st level spells a day, and can get 4 castings on one specific day (cast 2, long rest, cast another 2), but cannot do that every day, as they have to then wait 16 hours to long rest again. Long average, they can cast it twice a day.
Its a ritual. 20k gallons is a meer 5 castings or ~51 minutes of casting time.
Very easy and manageable, if you want to go hard core with it you can scale it much more aggressively.
That said, as a DM I would not rule that salt water is poisonous. You can drink salt water without making a saving throw.
Shape Water will move a 5ft cube (125cf/1,000gallons) 5ft every round. So you can easily "pump" water in/out of the vessel.
That is a cantrip, and so cant just be swapped in when you need it like purify food and drink can. Also, it is druid, sorcerer, or wizard cantrip, not a cleric one.
Its true, but this is also comparing it the Decantur, which is a "uncommon" magic item. It comes down to, what is more common in your world, a decantur, or a 1st level cleric and someone who can cast shape water.So, now you need a team of people, specially trained to take on the task.
Unless the cleric is High Elf, as those can swap their species cantrip on long rest. Or it's a High Elf with Ritual Caster.

(Dungeons & Dragons)
Rulebook featuring "high magic" options, including a host of new spells.