[Feature] Supports streaming read schema table

### Search before asking

- [X] I searched in the [issues](https://github.com/apache/incubator-paimon/issues) and found nothing similar.

### Motivation

Support streaming read schema tables, so that downstream can perceive schema changes of the paimon table

### Solution

_No response_

### Anything else?

_No response_

### Are you willing to submit a PR?

- [ ] I'm willing to submit a PR!

The issue names no files, tests, or entry points. Start by locating the streaming-read and schema-table implementation, then define the required behavior and tests for downstream consumers to perceive table schema changes.

Written by the indexing model from the issue text.