A rural housing project branded as ‘truly transformative’ has been completed