While they are often used interchangeably, "counselor" typically refers to someone who provides guidance and advice, particularly in a professional context, while "councillor" is more likely to be a member of a council.
So, while not a true homophone, "counselor" is the closest you'll get to a word that sounds the same as "councillor."