Enotes has a couple of resources you could use to explore your topic.
I would encourage you to read some of the works of Sherman Alexie. His novel The Lone Ranger and Tonto Fistfight in Heaven cites several personal instances of the effects of Native American Alcoholism on both the families and alcoholics.
You might also consider viewing the movie, Smoke Signals. It is also by present day author Sherman Alexie who regularly highlights the 20th century life of the Native American. You could get this movie at Amazon.com.
If you had a specific question I would more accurately address it, but for now, these are the ideas I have for you in beginning to research this topic.
It would be helpful if you could tell us a bit more about what you need. What you have given us is not a question and does not really tell us what it is you want to know.
In general, alcohol has been a real danger to Native American societies ever since contact with the Europeans. Alcohol became one of the things that Europeans and Americans traded to the Indians in return for various goods.
Alcohol became a real problem because Native Americans are, genetically speaking, much less tolerant of alcohol than are Europeans. This meant that they became drunk more easily and became alcoholic more easily. Thus, drinking disrupted their societies more than it did for whites.
This trend continues today. I would argue that some of the problem today stems from lack of economic prospects on Indian reservatons, but some presumably comes from the genetic problem as well.