The tourism industry in southern European countries like Spain and Italy could be under threat due to climate change, an EU report has warned.