I've usually heard it as someone who appears to be very sweet and innocent, but is in fact scheming and plotting behind everyone's backs.