Hundreds of tourists are expected to flock to Cork and Kerry this summer after 7.7 million people in Germany watched a television drama shot in the southern counties.