Council tenants moving into larger homes in Barnsley will be offered shorter tenancies, in a bid to address growing demand for affordable housing in the area.