Your (or the dog's) chances of being stung by a cicada killer are close to zero. They are extremely docile, I've even had them ride around on my shoulder while out in the yard. The males make a show of "aggression", they're basically attracted to anything that moves, but they don't even have a stinger.