LLB said:
If you are coming in from Morton in the Marsh end (also worth a visit), then you will turn off the A429 when signposted on to station road and when you get to a very sharp left hander with some shops in front of you, turn right and this is the main drag through the centre of the village, the pub is the 1st left and over a road bridge across the river and it is facing the river. Parking is a pain i the village though
It probably was the Kingsbridge. It is one of the bigger (nicer) pubs in the village.
They play 5 a side football in the river bed in the summer, and there is a ford at the lower end of the village which has caught many car drivers out due to its depth (been through it a few times in my 4x4, but always check first to see how high the river level is)
Usually full of Japanese tourists.
As BC says, not a huge amount to do as all the shops sell similar stuff.
Most people just head for Cheltenham town centre to go shopping if they come down this way, but you can kill a couple of hours wandering around Bourton.