It's hard to say. Yes, heroin can cause pin hole pupils and sleepiness. I hope it's not heroin. Opioids in general can cause this. Have you asked him specifically what he's taking? Does he have needle marks or any needles with him?
Could definitely be pain pills - or heroin.