Glasgow has formally come out in support of the decriminalisation of personal drugs use as the council continues to back the need for safe consumption rooms.