Custom stream wrapper which supports sftp

Hi, I’m actually searching solution for my drupal project. I want to override drupal public stream wrapper

I would to :

Send all the new uploaded files via Content > Media > Add or via custom field using entity browser to a CDN files folder
Getting all the needed files from this cdn, I mean getting files with instead of sites/default/files/my_file.txt
Keep local sites/default/files directory empty

There is a existent solution, via module or custom code ?

Thx !

Drupal version: