Oh, no, the waterways are not connected to the town's clean water supply. They mostly serve to keep the castle moat filled, and that water is boiled is we ever need to use it. ...Though this could explain why the moat is home to so few fish these days...