I'm a big fan of Stahl's Psychopharmacology. Since pretty much every illicit drug has a legal equivalent, but the legals are better studied, you'll probably find that a good source. If your primary interest is illicit drugs, though, I don't have a good suggestion - it's not the sort of book too many careers are built on.
I took a Biopsychology of Drugs class in college and found it fascinating. Do you know of any good (text)books on the subject?