How old is he ?
I solved a similar issue by setting up a water table in the backyard -- my water loving offspring stayed away from the kitchen and the bathrooms and would play happily in the backyard (for hours, if I let them). Whew, what a relief !
During the winter, I moved the water table into the laundry room (a small area), and contained the mess to that small area. You could also set up a water table in the bathroom (if big enough) OR in a corner of the basement (if you have one) or any enclosed and warm space during the cooler months.
Mostly water play is sensory and it is better to give access to it, rather than forbid it entirely (forbidding never works, anyway, as you probably found out).
Hope this helps.