Check out this post from lifehacker that gives a step by step instruction to install SNES emulator on iPad. You can also use Wiimote as an external controller to play the games, which makes this whole idea more exciting.
Here are some previous posts for installing SNES HD
Jailbreak your iPad to install SNES
Jailbreak iPad SNES Emulator