I believe what you are looking for is called a multi-WAN router. More specifically, one with a failover function.