At MGM Studios, The Little Mermaid show gives you "mist" a couple of times to make you think you are really underwater. Even more so down front. I feels good on a hot day.
You get somewhat of a mist from Fantasmic if you sit down front and the wind is blowing. Although, one time we went in February and could bearly see the show from the blowing mist and it was very cold. They used to have an announcer that said funny things. We were sitting in the Haddes section and he said it was called that because when you came in and saw the wet seats, you would say, "Hey des seats are wet." We later found out what he meant. Also, over in front of entrance of Backlot Tours, there's a hugh Coke bottle that sprays a mist. One more, on the Backlot Tour, sit on the left side of the tram you might get wet at Castastrophre(sp) Canyon.
I almost forgot about the fountains at Epcot that the kids play in. Water shoots up from the ground. I don't think there's any reason why an adult couldn't play(or stand) in them also. You would get really wet.