[ContentManager] Non-XNB asset path normalization accuracy

Fix for Issue #174:

- Make paths for non-XNB assets relative to program directory.
- Allow RootDirectory to be set to an absolute path.