Implement automated weekly smoke tests with GitHub Actions

[andylizf]

Fixes #4112

Implement an automated weekly smoke test run using GitHub Actions leveraging the existing tests/test_smoke.py script.

• Add a new GitHub Actions workflow file .github/workflows/weekly-smoke-tests.yml.
• Schedule the workflow to run weekly using cron syntax.
• Set up the environment and install dependencies.
• Run pytest tests/test_smoke.py --terminate-on-failure.
• Handle different test groups (AWS, GCP, Azure, Lambda, Kubernetes) as defined in the script.
• Add necessary cloud credentials as GitHub secrets.
• Upload test results as artifacts.