Charcoal filters aren't designed to fix hard water - you'd have to buy a fancy reverse osmosis or salt-based ion exchange system to soften the water.
A 5-gallon jug costs about $12, and less than $2 to refill. $15 on Amazon for a little pump that sits on top of the jug and you're good to go.