Yellow weather alert issued for waterspouts and thunderstorms