I modified the Grid 3D Niagara Fluid sample to make it look like water magic instead of smoke. It's a little difficult to simulate that seem to be moving fast, but I like how easy it is to do barrier-like things.
If I really wanted to make it look like water, I would just use FLIP. But that’s boring. I enjoy the challenge of making smoke look like water.