I guess you want to screen off the oil tank. 5 feet of height is not much for a climber. You could grow some short climbing roses such as Climbing Shropshire Lad, or an evergreen such as jasminium nudiflorum. Not sure about fruit trees if they will be exposed to strong easterly winds at flowering time, but if that's not a worry then you could train one or two as espaliers.
With the back trellis and fence you have a much wider choice. Roses, clematis, honeysuckles. Now is a good time to choose as the garden centres are full of fresh stock. get chatting to one of the more experienced staff members and ask for advice.