[FEATURE] add http session manager to agent

[joshua-stauffer]

This PR introduces an abstraction to manage agent http requests with cloud. It also addresses a bug where agent workflows failed due to duplicate resource names, after a recent OSS update changed the exception type being raised.

• [ ] Description of PR changes above includes a link to an existing GitHub issue
• [ ] PR title is prefixed with one of: [BUGFIX], [FEATURE], [DOCS], [MAINTENANCE], [CONTRIB]
• [ ] Code is linted - run invoke lint (uses black + ruff)
• [ ] Appropriate tests and docs have been updated

For more details, see our Contribution Checklist, Coding style guide, and Documentation style guide.

After you submit your PR, keep the page open and monitor the statuses of the various checks made by our continuous integration process at the bottom of the page. Please fix any issues that come up and reach out on Slack if you need help. Thanks for contributing!