Where in the world are you? Switzerland? Colorado? Alberta? Peru? Gibraltar? There’s no way to offer meaningful advice if we don’t know your climate.

I am located in Aistin Texas the weather is mostly hot and dry the flower bed is partial shade and partial sun .there is a sprinkling system as well

What you’ve planted there will get quite large. I’m not sure you’ll have room for anything else. Are those agaves also?

You have a lot of cement. I'd put the fountain on the cement.

A picture of the whole front of the house would be helpful.

If those are the species Esperanza, they are going to cover the windows. If they are E. 'Gold Star' they can easily be kept low enough.

What do you guys thibk about adding this founysin to the wall above the esortanxa cactus bed and put a small hedge in friont of it as seren in example photis?

I don't see any cacti but the white wall appears to be curved. A flat backed fountain would not look good there. It might fit on the stone wall to the left.

Ok what about a curved hedge against the curved wall with a free standing fountain ?

Here is what the entire front looks like (ignore the Christmas floats !) maybe this will help come up with ideas to make it look more "planned "