Major plans aiming to kickstart the regeneration of a derelict former glassworks site have been given the stamp of approval by city councillors.