Probably the most habitually pissy and violent wild snakes I've ever come across are rat snakes. Water snakes and garters generally seem to have pretty good temperaments, but I'm afraid to bring one in just for the heck of it because I'd worry about passing parasites/mites/ect. to one of mine.