From beaches with crystal clear water to new luxury hotels in Madrid, Spanish residents tell CNBC where they love to go.