Edinburgh Council has approved plans for 847 homes in the north of the city which is said is the largest regeneration project of its kind in Scotland.