it wont look better because its being scaled up,
but if you really need to, Compressor and Instant HD both do some extra stuff to the footage like smoothing and such.
plus it's not truly HD unless it was filmed with an HD camera, because of the difference in detail between recording in SD and HD, HD captures more information.