I don't know how strict they are about closing the pool at ten, it wasn't an issue for us. There is a sand volleyball court, and my kids thought that was cool, just playing in the sand. The playground is small. There is a tennis court and our unit had rackets and sand toys. There were only a few video games, which didn't interest us, but the exercise room kept my kids amused. They didn't seem to mind the kids being in there, in fact, I don't remember anyone "staffing" the club area, but I am assuming someone was there, it opens into the pool area.
There is a Walgreens very close by, and a Houlihans (not my favorite with children), also Denny's and other family type restaurants like that.
There did seem to be full time residents (based on the vehicles) but the four units that are "connected" that we stayed in were all rentals, and we were right across from the pool.
I hope you got a great price! It is a little farther out than many rentals, but it wasn't a problem for us. I preferred the less busy restaurants!