Movies have long had the power to spark tourist trends, but changing viewing habits and increased TV production values mean it’s the small screen that’s now inspiring serious wanderlust, writes Carolyn Moore