A Doncaster parish councillor is to be reprimanded and must provide written apologies to two women he made “rude” and “inappropriate” comments about, a city council hearing has decided.