I don't believe there are any hotels or motels in Stormville proper. Probably the best you'll be able to do is stay in Hopewell Junction; Arbor Ridge, which is primarily a catering house, does have an adjacent hotel which it operates. If there's a party going on there, however, it can get a little loud. Short of that, there are a LOT of hotels to the west in Fishkill just off of I-84. It'll take you a little longer to get to Stormville from there, maybe 15-20 minutes, but your lodging options expand dramatically out there and the quality is very good.
There is a motel just to the northeast in Poughquag, but online reviews seem to be rather poor.