An application has been submitted to create a lakeside holiday retreat at the site of an active quarry in Doncaster.