Lyn
We stayed at the CC site at Warwick Racecourse last year. I don't usually like racecourse sites but this one is actually quite nice, with some parts of it being no different from other CC sites. It's only a few minutes walk from Warwick town centre which is a lovely place, lots to see and do. You can spend a whole day at the castle if you want to. You can also walk right around the racecourse so it's great for walking the dog.
Just check for race days though, as I believe that some pitches may need vacating and access to the site is limited.
It's only a short drive into Stratford from the site.