The legendary actor-director was known for films like 'Butch Cassidy and the Sundance Kid', 'The Sting', 'All the President's Men' and 'Ordinary People'