Many thanks for all the replies, the Tweed gets my vote. Given the large amount of water on offer are there any tackle shops that I can get a ticket, some flies and bit of up to date advice from, not sure if the Cast around Peebles is a tackle shop or something entirely different
I'm quite excited as this will be my first fishing trip to Scotland which is crazy when you think I've been fly fishing for nearly 20 years

heres hoping the fishy gods are kind to me.
btw whose water will I be fishing, I assume its a club or association water ?