There are really only two broad possibilities:
1. Someone buys and continues the present business model; or
2. Someone buys and privatizes the entire affair.
In the latter case, expect the museum to be looking for another home. I guess that it doesn't really draw in enough paying customers to justify the space.
As for the Spring Ridge Club targeting this property, I would venture a guess it is unlikely. He doesn't need another clubhouse, but he could probably use some new leases, so that remains a possibility that he or someone else will seek exclusive fishing rights with the new owner.