How can I create the characteristic warp core sound?
You'll never do it with a 555.

Start by ripping a DVD of the TV show or movie.  Isolate the warp core sound.  Create an MP3 of that sound (and any others that you might be interested in).  Then buy one of these things, put it all together.  And you're done.