I was there last winter and hope to go back again this winter. Flew into Cabo and drove from there. Get groceries on that drive since its slim pickings in LV.
There isn’t much of a party scene anywhere, so that shouldn’t really impact your choice on where to stay. The town can feel borderline deserted until the wind comes up then everyone is out.
My suggestion is to stay at the southern end of town near Baja Grill. Its generally pretty quiet and the hiking or mountain biking in the cactus forest is awesome. We rented a house in the area through AirBnB and there are plenty of options. You could also stay at ChiloChill, which is a glamping spot on the beach that looked pretty cool, but maybe not as peaceful. There are a couple places you can walk to for dinner from that area as well (although more options in town which is a short drive). You can launch right in front of Baja Grill, ChiloChill or anywhere on the beach down in that area and its pretty beginner friendly. There is a very small reef in front of ChiloChill, but its very easy to see and avoid (although the waves tempted me too much and I wound up on it more than once!).
The most beginner spot is in front of Playa Central as it is a little calmer and shallower in there, but gets super crowded - I tend to avoid this area and go way offshore to stay out of the scrum. The north end of LV towards El Sargento (La Tuna) is better for riding swell. Maybe a slightly more advanced spot, but there are still plenty of beginners up there too. Wind at most of these spots is cross-shore, gets a little more cross-on at the south end of town.
You can park and play at any of the spots in LV, so shuttles aren’t mandatory, but If your skills are up for it I highly recommend doing a long downwinder from Aguas Calientes down to La Bufadora (or taking out at Baja Grill). Its a very manageable and relatively safe run, but you may get pretty far offshore in spots if you are chasing the swell. The run gets more technical around Bufadora (reef, steeper waves, more consequence), but most people take out before that anyways. Black Urchin is a shuttle company that I used a few times to run me up there. Downwinders Service — Black Urchin Services
Ando Flores from Saladita Kite School is a great guy and I’m sure his lessons would be top notch for you or your wife.
Another good activity for a non-kiter (or for a light wind day) is to get a boat to take you over to Isla Ceralvo. Very cool to explore the island, see dolphins, rays, seals, etc… You can snorkel around there, but there really wasn’t much interesting snorkeling that I saw around LV.