As investigative journalist and Irish author Tim MacGabhann reported on the drug cartels in Mexico, he was also supporting them through his own drug use. The experience helped inspire his debut novel, writes Marjorie Brennan