what would be a good climbing plant for a big stone wall that would be a good bee plant?

Looking for a neat vine to cover a stone wall and be good for bees also.

If you could mount some small eye bolts in the stones near the top to hang strings or wire from, you could have almost any climber/vine. Pole beans, sweet potatoes, cucurbits, climbing roses, or clematis come to mind.

What is your main objective - beauty, usefulness, or the bees? Do you prefer annual or perennial?