I'm not exactly sure I understand what the problem is, so maybe I'm taking a too simplistic view of things.
I don't know anything about fluids, so just imagine a truck with a hole in the bottom of it, and a human who drops boxes out of the hole, littering the frictionless roadway until all the boxes in the truck run out.
The person starts on the left side of the truck, and pushes a box rightward towards the hole. While the person is doing this, the truck moves to the left to preserve center of mass. As soon as the person is next to the hole and holds the box directly above the hole, she stops - then the truck will stop too (friction stops her, but that means she drags the truck back rightwards). She then drops the box straight down. Since she drops it straight down the truck doesn't budge horizontally, and no one is moving. She then empties the whole truck like this. Since there was more mass on the left hand side, the end result is that the truck moves more to the left. But center of mass of the littered boxes and the truck remains the same.
If you want to generalize this to giving the boxes a horizontal velocity when it exits the hole, that's fine. Just make the hole slightly bigger than the size of the box, and give the box a horizontal push on the way out. In this case it's possible to attain net motion of the truck when the truck is emptied, and in any direction.
Of course all the energy comes from the soda pop that she's sipping.
But what direction will the truck move? Well it depends. Place a cylinder wall around the hole. Now in order to dump the boxes through the hole, she has to lift the boxes a little higher and drop them through the cylinder. Depending on how the boxes undergo multiple bounces off the wall will determine the direction the boxes exit the truck. It could go out either way depending on how many ricochets there are. Therefore my guess for fluids is that it doesn't flow out all in one direction. It changes directions. Hence the motion is hard to predict. If the pipe is long enough (pipe corresponding to cylinder wall) my guess is that it leaks straight down, so the analogy with the boxes applies, and the cart will have moved left, but stopped once all the water had gone.