cherry-pick feat(stream): enable background ddl for StreamNow, StreamSource (#19099) to branch release-1.10

cherry-pick feat(stream): enable background ddl for StreamNow, StreamSource (#19099) to branch release-1.10 #3591