https://www.wayfair.com/FlorenceandNewItalianArtCompany--Newport-Concrete-Planter-Fountain

https://www.gardenloversclub.com/plant-finder/perennials/zone-4/

here I would redefine the bed, use mulch, solar spotlight, and again, hosta, fern and native plants.

I suspect that when you sit to look out the window in your living room that you don't even see the ground of the garden. Hence, for this garden, just find something that will grow and be satisfied with that. If you have no access to water, a water feature is going to be expensive and probably inoperable in the cold half of the year. Instead of a water feature, consider some sort of wind chimes. I would add a bird feeder and bird bath (that you would have to fill manually). This will give you something to look at with much enjoyment.

you can fill a water feature manually, just saying.

Phlox subulata might work around your sculpture. It's pretty most of the year (seems to be green under snow) and has lovely flowers in the spring. You can put bulbs under it. Another choice might be bearberry (Arctostyphilos uva-ursi). It's an evergreen ground cover that has white or pink flowers in the spring. It's slow to get established, but looks nice when it does.

Hostas do fine in dry shade, once established. I've had success with goatsbeard, too. Anything you plant needs to be well watered in the first year. After that, it really depends. If you never get any water there and don't want to drag a hose, then plants are going to be a problem.

The bed outside your living room contemplation window looks like it was already planted as a Zen type meditative garden, That rock, gravel, stump sculpture simplicity is what the conditions call for. You just need to clean it out and update it. If you want a fountain, look for one of those basalt column fountain kits which would work well in a Zen garden and be a sculpture in the winter when the fountain is shut off. Keep the source of the sound of babbling simple too. Trust me on this. Zone 4 is going to make your water incredibly hard.

Use a groundcover perennial around the sculpture like Nepeta or hardy geranium. Or move the sculpture to your new and improved contemplating living room window Zen garden.

Did I miss where in zone 4 this is, or is it a secret? Depending on the location, some of these suggestions will work. Which ones? That depends. We can also have secrets.

^^^^THIS!

Thank you all for your input! I I’ll work on these areas in the spring - you all have given me inspiration 😊