The Oscar-winning actor, best known for The French Connection and The Conversation, was found dead along with his wife and a pet dog