I am afraid you can get either good close up moon shots, or a cheap telescope!
You will need the correct tripod and mount and if you are going to take shots of more than a few seconds, you are going to need to drive the telescope.
Mounts are either equitorial mounts ( cheapest) or polar mounts ( expensive)
It all starts to add up!
If you want to connect your camera, you need an adapter of some sort. Either one to hold the camera over the eyepiece ( afocal) or an adapter that enables you to use the camera in place of the eyepiece.
Something like
this is a good starter scope and you will be able to hold a small camera over the eyepiece and get shots of the moon.
I dont think you will get down to crater detail.
For that you need something more substantial to hold the camera.
I used
this scope. It allowed me to attach my Nikon D80 and track objects for longer exposures to get shots like this...
Astrophoyography is addictive and puts a strain on your wallet. Theres
always something better in the shops....
Somebody else might have info on cheaper setups, but I learnt the hard way that there isnt a really cheap option.
Allan