My fountain only leaks when the pump is turned on and almost all the water is gone in a day? I know a little bit is expected to splash out but it can all be almost gone in hours.

It would appear that there is a leak in the pump line that only shows up under pressure. When the pump is off, there is no pressure.