A local authority’s ability to meet housing demand could be “fundamentally compromised” unless Cork’s city boundary is extended, top city officials have warned.