York and other North Yorkshire areas have been issued a Met Office weather warning for heavy rain and thunderstorms this weekend.