Opposition to development halves if new homes locally affordable