That's pipe resin. It is basically pot tar, you can clean it off tables with lighter fluid, and off of upholstery with disc brake cleaner spray, it will totally disintegrate it and vanish before your eyes.
It's usually used in the middle east for smoking flavored tobacco. Sometimes used for smoking other things. That she's using a hooka doesn't automatically mean drugs unless you know what she's smoking.