A strict interpretation of the rules leads to the conclusion that you still take a Sanity counter even if the assassination attempt fails (due to the revealing of a double-agent). A failed assassination attempt is exactly like a successful one except the active player does not place his control disc on the VP spot.
So this is the correct interpretation? Who draws the sanity token? The player who initiated the attempt or the (potentially new) controller of the agent executing the attempt?