Former quarry earmarked for holiday park scheme