There are fairly low cost overnight accommodation on trains in Europe, but it tends to be couchettes:

http://en.wikipedia.org/wiki/Couchette_car

proper sleeping cars where you have your own private small room are a lot more expensive.