It'll work with all cocoa apps so Adium included.
Once install, relaunch Adium, then press CMD + CTRL + A to make adium float above the rest.
Then press CMD + CTRL + F to vary the transparency and to tick 'make it paque while the mouse moves over it'.