I didnt realize I missed this....
If your deck gets some good sun, I would say Basil is a good choice, you could get a couple of different varieties and let them go to flower, once they do the leaves will get a bit tough, so you could start another small one as the established ones go to flower.
I am not sure where you are, and what kind of sun you get. but if you have public gardens and arboretums nearby, they might have some suggestions.
Thanks, CB. I'm in Boston and my deck gets good sun throughout the day. I have one shady spot, so I will try to find some mixed plants that will work for that spot.
CBs suggestion of basil is a great one. Really any herbs, provided you have sun will be good. And, you can use fresh herbs in cooking. Oregano flowers prolifically.
Do you have a cat? Catnip would be a good plant. Another plant that is great for bees and hummingbirds is called Cape Fuchsia (Phygelius), and there are smaller cultivars that do well in a pot. Don't forget Salvias and Penstemon, very pretty and bee magnets. The #1 plant that is a bee magnet here in the west is called the California Lilac (Ceanothus) and there are many small cultivars that work well in a pot.
I worked for many years as the help desk lady in a garden center. It would always crack me up when people would ask for plants that flower prolifically but that DO NOT attract bees. Really, why bother?
Echoes comment about a cloud of bees around a Wisteria made me think...a fragrant Honeysuckle vine in a large pot with a trellis would be great and the smell is heavenly.
Thank you so much for these suggestions. I actually have two cats and they would love the catnip, so that is definitely going on the list. I love wisteria, but I'm not sure how well it would grow this far north. Salvias are beautiful too, so I will pick up a few of those too.