A Secret Intelligence Service officer has claimed women are ideal for espionage. Looking back at some of the most famous spies, she has a point, says Paula Cocozza