Hi Kitty...
Your pup will love his crate! It will be his personal place of peace and quiet!...I'm pretty sure there a a fair few posts deeper in this section which will give you lots of advice, but this is what we did with Beetle...
Do note though, that I am a first timer, so the other posts will have far more experienced advice...
Beetle was in his crate at night (with the door shut most certainly) from Day 1....actually, since the breeder knew he would be crated, she started him off inside one, since he left home about a week after his siblings
For the very first few weeks, we had his bed at one end and a puppy pad at the other, but as soon as he was 12 weeks, he was holding on overnight for about 6 hours or so....
We didn't actually go down during the night either - although I think this is the general advice - to pop down halfway through the night when they are tiny to let them have a wee etc outside
Your pup may well howl for the first couple of nights....you may want to put the crate in your bedroom at first and then move it to the permament place gradually...but the key thing is not to go running to the crate to fuss him as soon as he howls - otherwise you will be creating a nightmare for yourselves!
The kids are not allowed to talk to Beetle when he is in his crate - it is his own space...
During the evening, he is on the sofa with us, but now and again will pop into his crate (we leave the door open, unless we are going to bed or out etc,...
At first, the longest he was left in his crate during the day was one hour, building up gradually to his now 4 hours during the day
Some don't put water in the crate with their pups (to avoid too full a bladder) but we've never had a problem there....
Thats all I can think of for now - but as I say, if you do a search on crates in the puppy section, you will be bombarded with posts with lots of good advice
Lastly - WELCOME!! and pics are obligatory!
g