Here are three options copied/pasted from the site cited. Follow the link to see other options, all very attractive.
Clematis (Clematis cv., zone 3+) - By far the hardiest of the showy flowering climbers, there are so many dazzling selections to choose from! They climb by twining their very supple stems and also by creatively bending their leaf stalks around suitable supports. Most of the climbing varieties are not overly vigorous, which allows them to be used in almost any garden setting. Keep the root zones cool and shaded while the tops bask in abundant sunlight for best performance. Note that different varieties of clematis will bloom on either new or old wood, and you need to know which is which when it comes to pruning in order not to trim off next year’s flowers!
Trumpet Vine (Campsis radicans, zone 4) - Not for the faint of heart, this is a vigorous and aggressive vine that will take up a great deal of real estate in short order. The tubular flowers, however, are spectacular and scream out for attention, standing off well against the distinctively compound dark green leaves. The species has flaming scarlet red flowers, while certain cultivars offer more subtle yellows. It climbs by twining, so give this guy an appropriately sturdy support structure and lots of room to grow!
Climbing Hydrangea (Hydrangea anomala var. petiolaris, zone 5) - This is one of the most artistic vines for climbing buildings and other structures with rock or brick facades. Both the dainty pinwheel flower clusters and the way the foliage is held contribute to its elegant appearance. It is able to secure itself by means of special “rootlets” with modified suction pads, so it can climb masonry and stonework. Unfortunately, it is only hardy in the warmest parts of the North.