Homeless people banned from camping in Moreton Bay streets and parks should be allowed to live at showgrounds, according to the city’s mayor.