Hello, if you want to collide with Niagara systems, your Niagara systems should have CPU collision enabled. So please make sure your Niagara water can collide with Static Mesh first.
If you still get problems, you can send me a simple project for test~ Thanks~