"Stay the night" is pretty generic. "Come visit me, if you can't find a hotel you can stay the night." "Stay for the night" is more rare, and in my experience might be used to indicate that it's only going to last one night. "His girlfriend kicked him out and he showed up on my doorstep, so I let him stay for the night." More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.