Gene Hackman's German Shepherd was found dead just metres away from his and his wife's partially mummified bodies following their devastating death