This the actual Footage was shot at John house for the effect shot

The breakdown from software 3D software Blender

In Blender software i did a fluid simulation on the shapes and place the footage for adjustments and bring the cilps over to Adobe After Effects for composting the effect to the actual footage.

AFTER EFFECT COMPOSTING 

  

From here i edited the rough shot to with the effect to blend in the footage testing which is better and adjusting the lighting to give that dark water effect in the scene

FINAL OUTCOME 

effect shot done and send the rendered footage to john for composting