You should wait as long as you want to. It could take you a month or two to open up to the idea of spending the night at his place, or you might even want to do it in the first week. Ask him what's okay with him, and do it whenever you want to.