Superconducting and microstructural studies on sputtered niobium thin films for accelerating cavity applications