Council leaders have unveiled a new plan to transform a scrapped film studio project, once linked to Netflix, into affordable housing.