Uninstalling it is easy. Open up Finder and navigate to ~/Library/Application Support/SIMBL. Here you will find the Keep Afloat plugin. Just delete this file and Keep Afloat is gone.
If you don’t using SIMBL, then you can uninstall that too. Go to the SIMBL homepage, download SIMBL, and run the uninstaller in the ZIP file.