Warning: This is 3.0 Edition material. It is possible that there is more recent 3.5 Edition version.
Inaccurate?

Sweet Water

(Defenders of the Faith: A Guidebook to Clerics and Paladins)

Divination
Level: Druid 2, Cleric 3,
Components: V, S, M,
Casting Time: 1 action
Range: Long (400 ft. + 40 ft./level)
Effect: A well shaft, 10 ft. diameter, up to 100 ft. deep.
Duration: Instantaneous
Saving Throw: None
Spell Resistance: No

This spell locates a source of fresh water within 100 feet of the surface.
If a water source is in range, it excavates a well shaft down to that water.
Otherwise, the spell fails.
Material Component: A shovel or spade.