A majority of Europeans say they feel sympathetic to residents who live in areas crowded with tourists