[SPARK-40478][DOCS] Add create datasource table options docs

[ulysses-you]

What changes were proposed in this pull request?

Add create datasource table options docs in docs/sql-ref-syntax-ddl-create-table-datasource.md.

Why are the changes needed?

improve the missed docs and example.

Does this PR introduce any user-facing change?

yes, docs improved

How was this patch tested?

N/A