Ok, my turn!
I highly recommend an RO/DI unit, especially if you're planning to go SPS like you mentioned. I used dechlorinated tap water run through a Brita filter for 6 months before bad water quality caught up to me (yeah yeah, don't laugh!)
I want to reiterate...I would NEVER buy water from anywhere other than a place with a well-maintained RO/DI unit. Commercial places will often use copper tubing=BAD.
Your water company should send you a report every so often telling you how bad your water is...granted, it doesn't tell you in aquarium terms.
I bought a well-used Coralife system off of eBay for $89+shipping (although the ad said it was barely used). I had to replace the membrane (Dow Filmtec 75gpd), sediment filter, carbon filter, and DI resin. I purchased the membrane from BFS (great service!) and the filters in bulk from BRS (Wow, that's confusing. BFS is Buckeye Field Supply and BRS is Bulk Reef Supply. LOL.)
I make about 15-20g per week for water change water and top-off water. For start-up costs and the cost of a new membrane and filters...I'm looking at less than 25 cents per gallon for a year of service (not including cost of water...I'm not converting cubic feet to gallons for ya...sorry.) The convenience is worth it to me...and the knowledge that the water is pure. After the first year of owning the RO/DI unit...the cost goes down to a couple of pennies per gallon + cost of water.
You mentioned not being allowed to plumb it. For a while, we just hooked ours up underneath the sink...and then took it out when we needed. It's not a permanent connection. You might have to unplug your garbage disposal so you have an inlet for it while it runs, but that's not hard (it's a screw type connection like a coaxial cable.) We decided to permanently stick it into the utility room, and unfortunately, the stupid house designers used plastic valves...and of course, the metal ripped up the plastic valves...and made a huge mess...and we had to call a plumber. I think that was a worst-case scenario.
You also mentioned what you should do with waste water. Right before I plan to do laundry is when I make my aquarium water. I just run the waste water line directly into the top of the washing machine...and run the water. Even if you don't fill the washer up, it'll still help your costs. Of course, you can always collect your waste water to water plants. Word of caution there though...(and I'm sure Jon in SW Ohio can pitch in), I believe some plants will flower too frequency with high-phosphate water (and yes, sometimes too high of flowering frequency is bad!) But for your common plants, it should be fine.
Hope that has helped!
Nikki