A local garden store or designer will certainly be able to help you. In the meantime, you can look up ideas online, but you'll need to know some basic information before anyone can help you choose specific plants. The first and most important is to know your planting zone, which is all about your location and climate. You also need to know the directional orientation of your house and the wall, and whether it is "full sun", "partial sun", or "shade". Will you be planting on both sides of the wall? You may wind up with vastly different plants if one side gets full sun and the other is in the shade. Take into consideration whatever shade is cast by the large tree, and the house itself. If you have the time, spend a day taking pictures of both sides of the wall - maybe once an hour (shadows will shift somewhat throughout the season), so you may want to do this every few weeks and keep a visual log of how the shadows move. Also, before you plant, decide if you want to paint the wall. It will be easier to paint before you plant, of course. White will reflect heat back onto plants. Climbing plants would look nice on the wall, if you're not going with a very structured garden. Ivy is an obvious choice, but there are other vines that flower beautifully, if you like that idea.

You must be in a tropical zone - I see palm trees .What zone are you in ? How long do you plan to live in this house and are you married to the grass ? How long and wide is the garden ? Can you make a shot from the fence toward the house ( house in center ) ?

The fence will end up being a modern picket fence, We aren't sure if we should grass the two squares or plant it out, it's a nice sunny spot, but we have nosey neighbours that we are trying to make disappear, if then it becomes more private then a seated area could be really nice, Hopefully the right plants will work or we will have to go with plan B, of installing barbed wire and two wild Dobermans!

We have very similar narrow side gardens. Judging from your picture, I'm guessing that you get more sun on the left. So, close to the door you could have pots of varying sizes and similar colour with dark leaf cannas and contrasting agaves potted, which won't overtake your garden because of the pot restriction. On the shade side, I'd plant ferns at intervals with clivia inbetween. You could also put up some chicken wire on the fence and train jasmine. On the sunny side, cordyline show-off, vireya rhodos, hibiscus (beautiful varieties) and bromeliads for groundcover. Good luck and have fun.