How much sun does this spot get?

My callistemon rigidus does really well in a 7 gallon container with low water. It seems to bloom almost all year round too. You can let them grow as a shrub, or what I'm doing, train them into a small tree. It's happiest with a lot of sun. I don't know how long I can keep it in a container though, it may grow out of it and I'll put it in the ground eventually.

I didn't notice it's drip tube fell out of the container one day when I was moving it a little and a few weeks later it was still doing fine. Granted this wasn't in the middle of summer in full sun, I'm pretty sure that anything would die in that situation.

If you don't mind a deciduous plant in a container, you could try a crepe myrtle. They grow as a small tree with multiple branches. I had a crepe myrtle in a container for a few years (I planted it in the ground this year) and it did fine with low water as well. It has a lot of showy flowers in the summer.

This one isn't as drought tolerant, but if the spot is shady in the summer, you could try to find a Michelia Figo. I'm very happy with both of mine. The flowers have a pleasant smell in the spring and summer (smells kind of like a baking cake. Some say it smells like bubblegum, I can smell that as well). They are perfect for containers as they grow slowly and never lose their leaves. They look a lot better when the soil is kept constantly moist in the summer. They pretty much require shade in the summer here in their first few years.

These are just what I've experienced so far, and I'm sure there are better plants for containers than these, so hopefully someone else will have some suggestions too.

A north facing wall is just about the hardest area to grow anything. Usually it gets full shade in winter and full sun in summer. If you use the search box at the top of this page and look for 'north facing wall' in the Arizona Gardening forum, you'll find lots of threads. Good luck.

I'd paint a mural on it.

I don't know how well they do in containers, but I had cannas on a north facing wall at my old house, and they did quite well for a number of years.