What you are seeing in parks is a pop up mister on an inground irrigation system. There are portable misting systems available.
Misting Systems, Water Sprinklers, & Mist and Irrigation Supplies from ACF Greenhouses There are also nozzles for water hose that can be adjusted to mist. Check your local hardware store.