A travel guide has highlighted holiday destinations which are "collapsing" under "unsustainable pressure"