Daniel Case says he felt a searing pain before looking down to see the 'whopping' snake hanging off his foot