The majority of council tenants on the new benefit system are in arrears, according to a council report