https://en.wikipedia.org/wiki/Heroin#Routes_of_administratio...
Wikipedia is surprisingly thorough on most drug articles. But you may even have seen such pipes for sale in stores... it can be smoked. Smoking various substances is pretty well accepted by society, even.