New details have emerged after the Oscar winning actor, his wife and their pet dog were found dead