If I battle a Pokemon with a HP stat of 200, then I use Super Fang over and over, will it leave the foe with 1 HP or will it "Kill" the foe?
No, I'm sure it will defeat the foe even though it has 1 HP. Look at this:
http://bulbapedia.bulbagarden.net/wiki/Super_Fang_(move)