Depending on the size of the sphere and how far it’s going to be from the camera, the distance field may not have enough resolution and at best the spheres would look like they are filled with hot play doh. The idea of having a fluid mesh rotating counter to the sphere’s movement sounds like it could produce more controllable results. More aggressive splashing effects could be done using actual animations or even vertex animations using Alembic.