The great majority of the currently operating rides and shows use some sort of water effect. In some cases, it's to represent water. In other cases, it's a stand-in to add a bit of extra immersion. But at Universal Studios Hollywood, you most likely will get wet.