The best transition that maintains the original intent of the two sentences is:
"Libraries are often seen as unnecessary; however, they should be valued for the many necessary services they provide to the community."
This transition effectively contrasts the perception of libraries with their actual value, aligning with the opposing views expressed in the sentences.