"Mission Impossible: Ghost Protocol", "Sherlock Holmes: A Game of Shadows", and "Young Adult" open in theaters; Jimmy Fallon will host the season premiere of SNL, "Dexter" and "Survivor: South Pacific" air season finales on Sunday