I've had mixed luck. A hotel in Whitehorse wouldn't let me bring my bike anywhere inside the hotel, not even a storage room. Other hotels and motels wouldn't let me keep it in my room but did provide secure storage in the hotel, or showed me where I could lock it outside where it was out of sight.

Other, generally cheaper, motels let me bring the bike inside my room with no problem. Maybe it varies by region (I've done all of my cycling on the west coast of North America) but I wouldn't count on being able to bring your bike in with you.