One of the first golf clubs in the UK to set up a flexible membership policy has announced it is going to close it at the end of this year because it is now too popular.