The young Connecticut schoolmaster's intelligence-gathering mission was ill-fated from the start. But after he was hanged by the British in September 1776, his story became the stuff of legend