(1) I agree with JedClampett. It's also important to note that the rankings are at least as much subjective as they are objective, and I strongly suspect the rankings don't reflect year-to-year changes in the programs. For example, I graduated in 1980 with a B.S. in civil engineering from California State University, Fresno. I thought at the time that this was a good, mid-tier program and my interactions over 40+ years with engineers from lots of different universities bears this out. I got a quality education--not as rigorous as the best schools, but better than many other schools. Unfortunately, within a few years after I graduated the program had hit hard times...and it's NOT because I left

. Many of the really good professors werre retiring, including the chair of the program, and the program had lost of a lot of the foreign students that kept our numbers and class offerings up. It took a while for the program to rebound, but I never really noticed a change in the rankings during this time, and I did check them every couple years just for fun. More important to me is ABET accreditation and the number of students in the program. Small programs have limited class offerings and may only offer some classes once a year and these can be cancelled if not enough students choose to take it. Large programs tend to be more well rounded and cover more subdisciplines within civil engineering. On the other hand, a really large program might intimidate some incoming students.
(2) I have mostly worked in a company setting, but I also worked for myself (and by myself) for a few years. In one small company, I was part owner. In another, I gained enough seniority to become one of about 100 stockholders out of about 600 employees. I currently work for a large multi-national, multi-discipline company and I plan to be here until I retire. Most of the one-man shops I know are structural engineers who work mostly for architects as a subconsultant. I also know a couple one-man shops who design subdivisions for small developers. The type of work I do mostly requires a team of engineers, drafters, and sometimes specialists, so freelancing really doesn't work here. Also keep in mind that civil engineers are heavily represented in government (e.g. city and county public works departments, regulatory agencies, etc.) and are also found in utility companies, software companies, etc.
(3) Unless the better university offers a real tangible benefit in terms of quality of education and starting salary, I don't think it's worth it, at least if you are thinking about a private university and have no scholarship money to back you up. Fortunately, civil engineering offers a better than average chance of paying back the loan. In California, the taxpayers heavily subsidize the University of California, California State University, and Community College systems, so the relative cost is pretty low compared to a private university. My three kids all started at a community college and this worked for their majors. Even though many community colleges offer lower division engineering classes, I usually recommend engineering majors start at the university level. Engineering classes start in the first semester and there is a lot of benefit to being in the program from the beginning. If money is an issue, I think a good California State University is the optimum choice, especially if there is one close enough to home to live at home for at least a year or two. Then, if you have to take out student loans, they won't be a back-breaker.
(4a) The standard workday is 8 hours and the standard workweek is 40 hours, but the real workday and workweek in consulting vary according to project requirements and deadlines. I don't write the following to scare you, just to alert you to the fact that some career paths involve more work than others. My longest workday was 23 hours (it would have been shorter, but a computer crash cost me several hours). I have a full man-year of 90-hour workweeks under my belt (a 4-month stretch, a 7-month stretch, and four individual weeks), and I have often worked 60, 70, or 80 hours per week. In most cases, this was due to inadequate staffing (for years, it seemed that every time we would hire people to ramp up for a big project, the same number would quit at about the same time). However, the 4-month stretch of 90-hour weeks was due to a client changing project requirements on a very large project up to the last minute but not extending the deadline. Ten of us were on this train ride. Over the course of my career, I have averaged more than 50 hours per week. On the other hand, I know plenty of consulting civil engineers whose circumstances have allowed them to average around 45 hours per week. In my current role, I average about 42 hours per week, which is MUCH better. Government engineers tend to average much closer to the 8/40 standard.
(4b) Project durations vary widely. My shortest project ever required 3.0 hours. A client had asked me to update a 5-year-old calculation I had done for him using new assumptions. My longest projects have lasted more than 3 years from the beginning of planning through the end of construction. Most projects I have personally managed lasted anywhere from about three months to one year from start to finish.
(5) You need better math skills in college than you need for practicing civil engineering. The four semesters of calculus and differential equations in a typical engineering program serve two purposes: [1] provide the mathematical foundation for subsequent engineering classes and [2] act as a gate-keeper for who should and should not be in the engineering program. Most of my math needs in civil engineering are covered by algebra and trigonometry. I have used calculus a handful of times (like less than half a dozen) and I do some simple statistics. I have solved one small matrix on a calculator. So, not too difficult. For the slightly more difficult stuff, I use Mathcad.
(6) ASCE and local engineers are the best source of information. ASCE will give you the overview and local engineers can give you the details.
(7) Most of civil engineering does not require a masters, but it can be beneficial. I don't have a masters because at the time I could have fit it in to my life, the nearest university that offered a masters in civil engineering was a two-hour drive away. On the other hand, I have more than the equivalent of a masters through self-study and work experience. A PhD is appropriate for narrow specialist, but less useful for a "regular" consultant. My company has lots of PhDs, but they are all specialists.
I hope this helps.
============
"Is it the only lesson of history that mankind is unteachable?"
--Winston S. Churchill