A developer has dropped plans for a luxury resort overlooking Frenchman Bay.