The transformation will time out after a minute or two, or you can click on the statuette again to turn back into a human before then. They can be used repeatedly. I kept a cat statuette as well, thinking it would come in handy to sneak into some place, but never found a use for it. Frog statuettes let you travel relatively fast, even when encumbered.
