qcon

qcon turns any terminal emulator for X into a Quake-style console. It is similar to tilda, kuake, and similar programs, but is't a terminal emulator by itself. Instead, qcon uses your favorite one, controlling its window position and state. It should work with most popular window managers and desktop enviroments.