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
Merge pull request #8220 from onesandzeroes/csv-output

API: Series.to_csv(path=None) should return string to match DataFrame.to_csv()