An inquest will be held into the death of a man who died after suffering a drug overdose