Cllr Sean Holden has joined MPs in calling for a new approach to tackle drugs despite fierce opposition from colleagues.