They like the bird bath; the back side of the laid down basketball backboard; any bucket that gets left out in the rain - especially if it has refuse in it; overturned black plastic plant pot rims - especially a stack of them. Flower pot drip holes - the plastic trays under potted flower trays. Just about any drop of standing rain water, rather than the 5 gallon dog water dish with lava rock that I keep full for them.
They found a bucket of leaves filled with rain water about 15' from the hives. The loved IT."My" waterer is right next to it, but they just don't seem to care for it (yet), even though I'm now eliminating all the mosquito breeding pools I can find (like the bucket of leaves).
The best thing I've found is a timed drip line to the bird bath, to keep it topped up. (The birds like it, too). The bees chose it, and I just modified it to keep it wet. My experience is that you can waste time trying to provide water for bees, or let them decide, & then roll with that. I suspect they have a number of other favorite spots around the neighborhood.
Of all the things I've seen, I suspect making a trickle down a stack of black plastic plant pots might work. Or not.