[ExternalSources::LocalSource] Improve handling of paths.

- Added support for tilde expansion
- Added support for relative paths
- Always return absolute paths for the Podspec.
[UserProjectIntegrator] Improve handling of the workspace