Angry residents faced with local population trebling under plans to house asylum seekers at former military base criticise the 'horrifying impact' on their community