Affordable car rental in Hexham for a weekend trip?

Has anyone hired a car from Hexham recently? I'll be arriving by train and need to rent a car for about a week to explore the surrounding areas. Looking for recommendations on which companies have offices near the station, typical costs, and any tips for getting the best deal. Also, are there any particular models you'd recommend for the local roads?