I've got one on my BIAB setup. It is the one from Bobby at brewhardware.com. I bought both nozzles just in case, but never had to switch from the lower flow (6gph?).
I too was concerned about the water use; however... I am on a well, so I don't 'pay' for it (though I don't like wasting it). I just had to get over it. Brewing generally uses a lot of water... while certainly you can reduce, it just takes water. My counterflow chiller uses substantially more than the condenser for sure... and then I use a bunch more cleaning. I feel most guilty when I 'soak' fermenters or kettles that I have filled for PBW/cleaner. But I am still brewing!
I love the condenser, and second the idea that you'll want to run the discharge tube directly into the drain. You do get a fair amount of odor with the condenser. Your house will smell very much like a brewery if you attempt to collect the water for later use. (Collect your chilling water instead for cleaning, as I do.) You can see how much the steam discharge has 'browned' my silicon tube due to the compounds (DMS, or whatever else) that are boiled off and drawn out.
If you haven't built your system yet... and are mildly handy... I strongly recommend installing a TC ferrule in your lid via silver soldering. I greatly prefer running the condenser out of the top. You don't lose any kettle capacity (for your mash).
I am a bit OCD, and didn't like the tilted condenser on the lid, so I figured out how to "muscle" the ferrule to be straight/upright before I silver soldered it. I didn't get it 100% perfect... but at least 90%. ;-)
Putting the TC ferrule in the lid also allows the opportunity to build a little gadget that can be used for recirculating your mash, and whirlpooling after. All uses the same TC ferrule. (BobbyM modified a "spincycle overboard"... used the tube with a compression fitting welded to a 1.5" TC cap. I can move the tube up or down , and lock it at whatever height via the compression fitting. Have it just below the surface for mash recirc... and drop it lower for whirlpool after boil.)