Recently re-opened after an $11-million resort makeover, Sandpiper offers personalized service to groups up to 125.