[Bug] When arrow-flight is used and the FE private name name is not resolvable, the client cannot access the FE nodes

### Search before asking

- [x] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.

### Version

4.0.5

### What's Wrong?

Setup a k8s cluster with FE/BE and add arrow flight ports. You can tell the BE that it has `public_host` and `arrow-flight-proxy-port` just fine. But you cannot do the same for the FE. It returns its internal name and redirects the client to that name to pull data (such as from `show tables` or `use mydatabase`). For queries that return from BE it runs fine, but not those from FE.

There should be a similar `public_host` and arrow flight proxy port for the FE, not just the BE.

### What You Expected?

A setting in the FE that allows a public host and port to be selected when the driver returns a host for arrow data retrieval. And likely similarly for other URI for web data access.

### How to Reproduce?

you cannot do this, the settings are missing.

### Anything Else?

please?

### Are you willing to submit PR?

- [ ] Yes I am willing to submit a PR!

### Code of Conduct

- [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)