By any chance has anyone created a Yatching Club Lot that you could place on a lake/
The yacht club can be placed on any body of in game water (including a lake) so long as the reward is unlocked.
It is either done by meeting the conditions or by using the 'youdontdeserveit' cheat. Same goes for the custom resort/yacht clubs by GDV: https://community.simtropolis.com/files/file/2999-gdv-waterfront-hotel-plus-growable-resort-hotel/ (https://community.simtropolis.com/files/file/2999-gdv-waterfront-hotel-plus-growable-resort-hotel/), https://community.simtropolis.com/files/file/3154-gdv-yacht-club/ (https://community.simtropolis.com/files/file/3154-gdv-yacht-club/)
Now if your question relates to 'ploppable' water then there is only one or two that I know of which is more of a resort:
https://community.simtropolis.com/files/file/11423-peg-lakeside-resort/ (https://community.simtropolis.com/files/file/11423-peg-lakeside-resort/), or http://sc4devotion.com/csxlex/lex_filedesc.php?lotGET=2394 (http://sc4devotion.com/csxlex/lex_filedesc.php?lotGET=2394)
Appreciate the reply and the links. Many thanks