The chief executive of Cork City Council has defended a €32,000 spend on its dog fouling awareness campaign after figures showed just one fine has been issued for the offence in seven years.