[DataCatalog]: Add functionality to search datasets in the catalog

[ElenaKhaustova]

Description

Users struggle to find datasets within the catalog, particularly when dealing with a large number of datasets. They express the need for search features to facilitate dataset discovery.

Context

"As a user in my list object, I can filter by name but I can't filter by what. So it would be good to be able to say give me all the sql datasets and then the names of the tables that are attached."

Comment form @astrojuanlu: Kedro Viz has an item in their roadmap to include a table view of all the metadata, could help with this.

Possible Implementation

Integrate search functionality into the catalog, enabling users to search for datasets based on keywords, patterns and by kind. Include support for regex search to accommodate users with advanced search requirements.