For particle fluids using a bunch of circles with the physics behavior like it the video is probably the easiest way. However the physics behavior uses it's own collision detection so it isn't affected by the collision update.
A more realistic motion of water would just be water particles that repel each other with forces instead of collision impulses. With that particles would only need to repel other particles close by, in which case the collision update might help a bit.