Indeed, generally, it will self-limit, and in a well-ventilated space, will sink and disperse. The smoke isn't carbon dioxide, it's mostly condensing water, which will freeze on the surface of the dry ice. Chucking it in a large volume of warm water though will prevent this and the dry ice will likely be entirely converted to gaseous carbon dioxide. Pool complexes are not renowned for their ventilation, no one wants a cold draft when they're in their speedos.
Back in my science days, we used to have a fair quantity of the stuff, it was standard to extract and purify nucleotide metabolites in a freon-113/percholorate/tri-n-octylamine phase on dry ice. I miss having fun with chemicals.