Last time we were down that way we got a B&B in Rothbury, but mates parked in the Carp Ark on the S side of the river and had no hassles (it was late in the year though, and I think the campsite was closed). From there you can walk to a selection of pubs and restaurants.
(edit - just had a look on google maps and it's the parking for the sports fields. There also appears to be another smaller car park on the far side of the sports fields . However, there is also a road that goes behind the sports fields if you take the road before them and then go left, which looks pretty quiet at the end).
Otherwise you could probably park up in the woods at Simonside, but don't think there is a pub in walking distance. Last time we were there though, there seemed to be a few people congregating in the evening, so it might be a popular spot for night partying.