A Northumberland golf club that has financially struggled in recent years has been given the green light to have nearly 100 new homes built on part of its current course to prevent it from closing down.