I can't recommend any website, but I was in Madrid this year during the San Isidro festival and LOVED it, there were open air concerts for free on the Plaza Mayor, and it was packed with happy people having a good time, dancing, having a calamares sandwich etc. I hope I can be there next year, too. For sure, in June good weather is even more secure, but in May you already have a fair chance of nice temperatures.