Hi Tony,
Best recommendation i can give is the Bahamas bit far to go for a weekend right enough but you can always use your private jet to "Pop" over.
No seriously Stella Maris resort in the Bahamas on Long Island. It has the world's deepest drop off and some of the best visibility i have ever experienced and i have dived all over the world.
http://www.stellamarisresort.com/diving.htm I know Jorg the owner as we are buying some land over there and will quite happily put you in touch with him.
If taking the missus and the brats they will do you a deal on renting one of the seaside cottages at awesome rates.
Regards
ScottyB
[Edited on 28-8-2005 by ScottyB]