The Vera finale put a Northumberland village in the ITV spotlight on Thursday night as the hit drama came to an end