The theory that smoking out of tin cans causes an increased likelihood getting Alzheimer's disease stems from the fact that tin has been shown to do this. However, these cans are made out of aluminum. Although I would never personally do it because I have enough sense to go buy a pipe, there is probably little harm that could come from smoking out of this.
BTW, why wouldn't you just use a water bottle?