Yakuake is a drop-down terminal emulator based on KDE Konsole technology which looks like the Quake console coming down from the top of your desktop when you press F12.
A while ago I wrote an article called 13 Terminal Emulators for Linux, where I briefly reviewed all those popular shell-like applications and a few flavours of xterm or rxvt.