I grew a climber rose in a half barrel once.
You need to look at some rose web sites to, There are loads, scented, or not. I have been given a Lady Hillingdon, that has a wonderful scent, but probably will be too big.
This rose is from David Austin. the re is another called Graham Thomas that can be a shrub or a climber. It is supposed to be amazing, perfume and disease resistant, and a good yellow colour. that also is a David Austin one. It's on my wish list.
http://www.davidaustinroses.com/