Plans to demolish and replace a Sunderland school with modern state-of-the-art facilities have been given the green light by city councillors.