These are sand wasps. They are a solitary wasp that lives in a burrow underground. I have never had any of these be aggressive. There are lots of other wasps that look similar. I doubt you have sand wasps since they don't survive wet ground conditions. I have also never seen these in the water.I can’t stand those things. They get in my pool all the time. Their sting is not that bad but it’s still aggravating. Great pics!