"A really lightweight Linux distro", this doesn't makes sense at all. The Linux kernel is the same for everybody, it depends on what your are running on it.
Pick your favorite distro, just install a tiny window manager, avoid running background applications and that's it.
If you don't have a favorite distro, then all depends on your Linux skill and/or the time you have. Good distros have already been given in this thread.