Here's one:
East Brothers Light Station
http://ebls.org

Not in the US, but in Newfoundland I stayed at the Quirpon Island Lighthouse. You actually sleep in the Lightkeepers house, not the lighthouse itself.

http://www.linkumtours.com/site/inns.htm

An intriguing question. This link looked useful:
www.uslhs.org/resources_accommodations.php

Try this link for lighthouses in New England.

home.comcast.net/~debee2/Lodging.html

There are several in Michigan along the Great Lakes...google it

Is this close enough to what you want?

http://hecetalighthouse.com/bed-breakfast

The Heceta Head bed and breakfast is not staying in the lighthouse- its the lighthouse keepers home - but I a have stayed there and it is a fun experience, great food and overlooking my favorite beach in Oregon!
Highly recommended

http://www.lighthouse.cc/links/overnight.html

You can be the lighthouse keeper at Dungeness Spit, but it is a full week commitment:

http://www.newdungenesslighthouse.com/

Hostelling International has 3 options in ground quarters next to lighthouses. Pescadero Point is 25 miles south of San Francisco. Pigeon Point is 50 miles south of San Francisco. My DW and I stayed at Pigeon Point-the free wifi even worked.
You should check out Tibbets Point Lighthouse at the west end of the Thousand Islands in New York State if you want to bein the east.
If you just want a small room in the top of a tower, I can tell you where to rent a fire tower from the USFS.

How about Big Bay Point Lighthouse Bed and Breakfast or Sand Hills Lighthouse Inn?

http://www.bigbaylighthouse.com

http://www.sandhillslighthouseinn.com

Keith

Thank you all so very much. Big Bay Point looks very promising.

THANKS!!!

Lighthousebb.org. It's at Two Harbors MN, about 40 miles north of Duluth. There are only 3 rooms in the lighthouse itself--there's a 4th room in a little building a few steps away.

When we were there a few years ago, there was no innkeeper on site during the night. Someone comes in in the morning to cook a nice breakfast.

We hugely enjoyed it. There's also a bridge from a Great Lakes freighter on the grounds--be the master of your fate (and out of harm's way!)

The last post from the original poster was March of 2011- I doubt she has been checking for recent responses

If she did stay in a lighthouse, I hope she shares her experience.

Sunburn, I just checked and Dowab does nothing but post links to that oddinn web site.