Load-balancing and failover are a little bit different but both probably work best when both lines terminate on the same router.
If you get a modular router (like a Cisco 3600 or 2600 series) you just specify the modules you need. The fiber/IP will probably require an Ethernet interface and the ADSL may require either Ethernet (for an external modem) or a direct plugin.
If you use a properly configured routing protocol, when one interface drops, within a short period of time (the convergence interval), the routing table will adjust to reflect the downed link and all the traffic will go out over the other one.
Load-balancing can take several forms and can be quite a challenge to implement properly (more so if the ADSL and Fiber/IPconnections goes to different ISPs). But it can be done by several different methods. For example, you could send e-mail and Web browsing over the slower link and file transfer or streaming video over the faster link. Or you could send certain IPaddresses (the boss' workstation) to the slower link and others (your workstation) to the faster link.
paul