thanks for this will look into it.Not north of England but we spent NYE at Longleat C&MC last new years and doing the same this year.
As we have 2 9yo they loved the Festival of Lights at Longleat and the fireworks display was very good also.
I suppose it may depend on if you have kids with you.
I sure some have spent NYE at Tan Hill Inn which is not that far from you....
New Year 2020 - Tan Hill Inn
www.tanhillinn.com
The meal may have sold out but you may be able to camp drink enjoy the music etc.
The VW California Club is the worlds largest resource for all owners and enthusiasts of VW California campervans.