Children's Books Daily has a list of 100 of the best books for children on sustainability, including many on water issues.
Other sites listing useful books on water (and other sustainability topics) include: