A community-led report capturing the views of more than 1,600 people across the city is urging the council to manage second homes and holiday lets.