Permission for a 23-home development in a Herefordshire village has been granted, more than six years after it was first applied for.