Native American rain dances are simply to thank the rain for, well, being rain! Being Native American, when I lived with my parents before moving, we used to do one once a month, simply out of tradition. They are not used to summon the rain.
There isnt any spells that could make the rain fall, or a thunderstorm come anyway. The rain naturally happens because warm air can hold a hell of a lot more vapour than cool air, so when warm air eventually cools, it cant hold as much water vapour. So, the water vapour has to condense, and then it comes out as rain.
No human being can control that; and ignore any spell that you see saying that it does is lying, ignore it!
Nobody can create a thunderstorm, or produce lightning from the sky either. Here is a link to explain how thunderstorms are formed, and you will see my point on why a human being couldnt make it happen from the sky.