Improve error message when local filepath is not found

[astrojuanlu]

Description

This is the outcome of #2965.

When a local filepath on disk fails to be found, instead of a plain No such file or directory, the error message should include what the Current Working Directory (CWD) is.

[ElenaKhaustova]

Previous error message: #2965 (comment)

Currently, the error message uses absolute paths as well as datasets when printing them:

DatasetError: Failed while loading data from dataset
CSVDataset(filepath=/Projects/kedro-tests/filepath-error/do_not_exists/data/01_raw/companies.csv, load_args={}, protocol=file, save_args={'index':
False}).
[Errno 2] No such file or directory: '/Projects/kedro-tests/filepath-error/do_not_exists/data/01_raw/companies.csv'

So no changes are required.