API: Series.to_csv() should return string when path is None

Test cases for when path is None

Return string when path is None

Add note to release notes under API

Add comments to test cases