We are playing at Scarborough this year, and we're planning to go as it's not far from us here: will be doing some research about accommodation so will post anything we find on here.
As for Headingley: when Yorkshire dropped into the second division briefly the other year, we went to the Yorks v Essex match there. Stayed at Headingly Lodge: great value, as our room rate (about £55 per night) included being able to park in the ground and, of course, there was no entrance fee (we're Durham members, so were non-members for this match). Their policy for the Lodge is that the rooms are only used as hospitality boxes at Internationals and major matches, so available as bedrooms for county matches.
Lynda and Steve