You can form a fountain in the middle of a pond in which goldfish swim. It will be very beautiful.
The pressure of the water and the height of the fountain will depend on the power of the pump. The pump usually works on electricity. There are already modern pumps working on sunny batteries. But they have small power.