The Mayor of Naas Darren Scully has said he will "reflect on his position" after a race row erupted when he said he would no longer represent black Africans.