Sorry but if you are looking for drinking on the streets of Sturgis, you are out of luck. The streets are patrolled and any public drunkenness or drug usage is dealt with pretty strictly. In other words, there isn't any. If you want to go see some beautiful bikes (and women) by all means go.
Now days most of the bikers are dentists, teachers, lawyers, etc.