You have to change trains at least two times, once both in Germany and Holland. If you want to stay the night in Cologne, Hilton, Marriot and Starwood all have properties within walking distance of the main station. But as the journey is only around 3,5 hours you could also just continue straight to Den Haag.