The latest census results have highlighted the need for more investment in public transport and cycling infrastructure in Cork, according to local representatives.