'Tired' shopping centre set for demolition as 'ambitious' revamp approved