Can we use S3 bucket as input in function beat and send data to some ingest pipeline

Not yet. https://github.com/elastic/beats/issues/11603

There is support in Filebeat for reading from S3. It can monitor an SQS topic for notifications of new files in a bucket and then consume that file.