Since it doesn’t seem to have any way to grow water plants or keep fish, it seems somewhat uninteresting, except for the rocks. And it looks artificial in its location. A more formal pool would look frankly man-made, not pretending to be a naturally occurring feature. I’d take it out. There was a small, deep concrete pond at my house when I bought it last year, with water plants and deep enough to keep fish all winter, but I didn’t want the maintenance and it was in a strange location where you couldn’t really enjoy it very well. When we had some construction work done we had the backhoe guy pull it out. I’m glad I did it. I wasn’t interested in draining it every spring and climbing into it in my wellies to clean it out.

To sooth your sole that would need to be a sea water feature ;-) (Sorry. Couldn't resist)

A pondless fountain like this needs a pond pump Not a sewage pump. It is really critical that you have the right pump and right size pump for the job you are asking it to do. Also if it is not going to be run continuously, you must have a check valve to prevent the water from running the pump impellers backwards when it shuts off. That alone can shorten a pump life significantly.

Go to Pondliner.com. They have calculators to help determine the size pump you need.

With any water feature like this there is going to be maintenance period and the pumps will have to be replaced periodically. You should be able to get two to fours years from the right pump though.