It's not a new book, but a classic children's books with stories scary enough to get the hairs on the back of your neck to stand up, but still have a peaceful sleep afterwards. Scary Stories to Tell In The Dark by Alvin Schwartz is the book you need. Not only are the stories spine-tingling but the illustrations add to the creepy sensation. Stephen Gammell's illustrations in the original editions are perfect. How else can I describe them? The fact that they're only in black and white and are realistic but also dreamlike nature to them, adds so fully to the readers experience. This is a book you have to physically read and enjoy for that reason.
There are scarier stories included in the volumes as well, but since it is a book for children (8-12), it's pretty mild. And if these illustrations are a bit too scary for you, there are newer editions out with new illustrations by Brett Helquist that aren't quite as chilling as Gammell's.