A flip mirror (either integral to the 'scope or as an accessory) will give both options.
If you're not sure whether you want to use a tripod, then consider image-stabilized binoculars. Firstly, you won't be able to hand-hold a serious telescope, and secondly you won't be able to locate/track a moving target with an angled viewfinder.