Through-walkable object with collision!
You can have the water detect collisions and not actually register any collisions by setting it to ghost.



Once that box is checked, anything that hits it detects the collision, but it physically treats it like a no-collision mesh. So, you can simply have a logic setup similar to this one on your character.