The new Lord Mayor of Cork says he is confident that a “fair compensation package” for the county council can be worked out to secure a city boundary extension.