People are about to move into their new eco-friendly homes as part of £19.5 million affordable housing development in a North Yorkshire village.