I haven't found any similar thread wherein this sort of discussion has started.
TL;DR Version
Care to share your successes? Some ideas for discussion:
Rain water harvesting.
Grey water harvesting and how to improve its quality for garden usage.
Borehole water: feasible, cost effective...