Councillors overwhelmingly backed a motion to protect council tenants and employees who are legally prescribed cannabis for medical purposes