Heres what it comes down to. Reverse Osmosis is going to clear the canvas for you. Get you down to pretty pure water and then you can perfectly control the nutrients. I do it. But it may not be necessary for you.

Hard water will effectively reduce yield (because of what I said before).