A public golf course in Dundee, where membership has dropped to less than 100 people, will close down next year as its local council wants to save thousands of pounds of public money.