If both servers can be live at the same time, then you can just add both as proxied DNS records and if one is down, Cloudflare will pass traffic to the other…
If you specifically want one server to handle all requests, then fail over to the second only when the first is not available, you need to use the load balancer…