You can certainly create a file event for a file that exists on a different server, as long as you can access it via UNC path.
However, there’s no direct way to use a file in FTP or SFTP as a trigger; you would have to set up a separate process that would regularly do a copy from the FTP location to the local server, then create the file event using the local path.