Although many places rely on tourism for their economic survival, some cities are finding that better management of tourist numbers is required to quell local disillusionment