A plan to build nine new houses on the edge of a Herefordshire village has been approved despite widespread local opposition, in what could be a sign of more to come in the county.