What snake bite causes localized tissue destruction around bite site?

Many poisonous snakes can do this. Some being rattlesnakes, copperheads, and water moccasins.

Those snakes with venom that is primarily cytotoxins (vipers, etc) can cause severe tissue damage. Those with neurotoxins (cobras, corals, etc.)are less likely so do so.