A sleepy Northumberland village was thrust into the spotlight in the finale of one of the UK's best-loved detective dramas.