In terms of accommodation Pisa has all sorts of places, hotels, vacation rentals etc. Just browse the reviews on TripAdvisor or take a look at FlipKey if you are looking for an apartment.
In terms of restaurants, the only thing to remember isthat the closer to the tower the more touristy and expensive restaurants will be.
My favourite in the city are La Pergoletta, Osteria di Culegna and Le Repubbliche Marinare, but Osteria dei Mille, Vineria di Piazza, Modus Bibendi and Osteria dei Santi are also very nice and affordable.
The night life is in the area of Piazza Garibaldi and Piazza delle Vettovaglie, but for your accommodation you might want to choose something not right there because it gets very noisy at night.
November can be rainy but it is hard to say. The city is very nice because it is in full swing, with the University back in session and the students back in town. The second half of the month is all about Christmas already so the city is nicely decorated.
Pisa is an excellent base to visit surrounding cities too with public transportation such as Lucca or Florence. You will love it.