A plan from over a decade ago to build eight affordable houses for local people in a Herefordshire village has now been formally dropped.