I've been using a Nimbus Watermaker Mini Faucet-Mounted RO for about 6 years. It produces about 10 gpd, and attaches to the faucet. Not a lot of water, but it has served my drinking and plant watering needs. It brings the ppm down to about 10 ppm. My local water is 95 ppm.
I broke the plastic housing on the Nimbus, and decided to try another system. I bought one of those Zero Water systems. It brings my water down to 0-5ppm! They even throw in a ppm meter! There is absolutely NO waste from this system. It's like a Brita filter on steroids. You can get a pitcher unit for about $30, and a larger tank that fits on a water cooler. Pretty cool unit for a small grow. I think that the filters need replacing fairly regularly, but with my tap water being only 95 ppm, I won't have to replace near as much.