The Ministry of Defence is having a “devastating impact on communities” by selling off land that could be used for housing, according to one of the largest trade unions in Britain.