An orange weather alert has been issued for a top tourist Spanish coastal area as it braces for a dramatic thunderstorm and heavy rain on Monday evening.