I currently have a species of Bumblebee goby. It was sold to me as Brachygobius xanthomelas, but it probably isn't that. I keep mine in a 5 gallon (the tank is a UNS 45S). The species I have is very tiny, smaller than Dario dario.
There are many different species that are called "bumblebee gobies", though they do have similar requirements. Depending on the species you get you can keep them in quite small quarters. I found one account of someone keeping a group of Brachygobius xanthomelas in a 12x8x8in aquarium, and getting them to breed. These quarters are probably a little too small for a larger species Brachygobius nunus. A 10 gallon is a very safe size. You could go smaller depending on the species.
Substrate is irrelevant, they don't interact with the substrate at all as far as I can tell.
My bumblebee gobies are by far the pickiest eating fish I've owned. They take live baby brine shrimp or blood worms if I wiggle them around in front of their nose with some tweezers. I have been completely unsuccessful at feeding them dry food. This is the most difficult thing about them in my opinion.
While all previously believed to be a brackish exclusive species, we now know that bumblebee gobies come from blackwater freshwater environments as well. You don't need to keep them in a brackish tank, and they can be perfectly comfortable in soft freshwater. I would ask the person supplying the bumblebee gobies what water they were kept in (brackish or fresh), and I would keep them in that water initially. Then you could try weening them onto different water (e.g. if they were kept in brackish, I would start them in brackish and slowly reduce the salt content in the water over the course of a month). I would also try to ID them. Their species is quite important to how to keep them.
I'm currently keeping mine with Dario dario and they seem to be getting along. Bumblebee gobies are territorial with eachother and they will squabble. I would recommend getting a group of Bumblebee gobies and let them set up territories. I would return any that fail to set up a territory as they will certainly get bullied to death
Personally, I think these little guys look great in a tank with lots of leaf litter.