First, did you know that most library ebooks can be sent to your Kindle account and read on the Kindle Fire?
But if you still want the OverDrive app, you can download it from OverDrive and install it yourself:
http://www.overdrive.com/software/omc/default.aspx