Commander Julian Bennett, who wrote the force’s drug strategy, offered his resignation when he was accused of using the substance