Formidable and popular council leader who served the city of Newcastle for more than 50 years, committed to raising standards of living