Animate a water fountain

Hi all,
I spent about 6 hours watching tutorials, reading and experimenting, to get a simple (?) water fountain animation. I give up and humbly ask for help.
The setting:



The top basin is supposed to overflow to the lower.
The desired result is a still image or a short gif of the action, not the animation as a whole. I managed very basic and unconvincing results, in two separate attempts:

  1. In this I try an inflow object in the form of a pipe on the bottom of the top basin, shooting water up (Z-axis), so that the water fills and overflows to the lower basin. The idea was that eventually the bottom would fill up too and I would get the shot I’m interested in.
  2. In the second I thought I may skip many animation steps by having the top basin filled and making an overflow object, sitting on top of the lip of the top basin and shooting water to the side (Y-axis) so that it lands on a water, fluid below in the lower basin.

Both miserable, really.
You can download the 2 files from WeTransfer
Can someone please look and edit my blends?