Recent Census results have highlighted a need for more investment in public transport and cycling infrastructure in Cork, according to local representatives.