Use Kedro pipelines as tools

[ElenaKhaustova]

Description

1. Wrap Kedro pipelines as callable tools that can be invoked by an LLM agent (like OpenAI, LangGraph, Autogen, etc.)
2. Showcase how to reuse Kedro pipelines across agent frameworks as a "skill".
3. Suggest a business use case and create a demo project for it

Context

#5012
#5013

[datajoely]

I see this as a wider session / fastapi issue, we need to be able to pass ephemeral data to a pipeline run as a fundamental feature