Your chances would probably be slim to none anytime soon. Stay clean and finish your degree. Due your past use of drugs, you would be disqualified by some departments, but in time, a number of years, you could still get hired by some departments. Becoming a homicide detective is usually not easy. You usually have to be a good police officer, and there is often much competition.