It can be added to existing houses, but won't come cheap.
We are undertaking a large job at the moment, the bio-water system is $20 000 (about $12k to purchase, another $6-8k on the install).
Probably one of the more green and of course costly things you can do.
Look at an Odyssey...