One of the country’s largest trade unions has called on a local authority to scrap plans to lease some of the vacant council homes it cannot afford to repair to voluntary housing groups.