'Nimby' villagers who tried to buy a housing plot to stop a new development have lost their £8.7m bid