Think of the food production alone - assuming a colony of a few thousand people, that would mean you'd need to be growing hundreds of tonnes of food at any given moment - most of which would consist of water you've brought with you (for example, a cabbage is 93% water). Of course that could largely be recycled, but even if you can get to 99% recycling you'll still need a rocketload of water very regularly to replace the water you lose or that's polluted beyond recycling.
It really doesn't make sense to take water with you. Just colonise somewhere that already has it.
Well, can't you recycle ~100% of it? So you really only need to ship the maximum amount of water that will be in use at any one point.