Bees

Stingless bees
There is a species of bee that has no stinger, produces edible honey, and is not aggressive towards people. See Tetragonula_carbonaria or this Science News article.

There are many types of stingless bees. The article at Stingless bee gives information about them, including one that is so tame it won't bite back even when you are removing honey from its nest.

Mason bees
Mason bees are not aggressive, since they don't produce hives to defend, and are better pollinators than honey bees. But since they don't produce hives, they don't produce honey either.