As two big exhibitions are shedding light on the art of espionage, experts reveal what it takes to be a great spook - and why Jackson Lamb might be better at the job than 007