Half a century ago, a group of friends created a sports association and put down roots in a house overlooking the Douro. The club that tourists love wants to modernise, but without losing its local spirit.