A functioning water purifier in a settlement where water production exceeds consumption will produce Purified Water for you to take (once per game day or so?); they are stored in your workshop inventory. Keep in mind that your defense should be higher than water and food combined.