B.Sc

Only 2 colleges offer agriculture in Kanpur: https://goo.gl/1oJCvh

B.Sc (Hons) is much more specialized as compared to the B.Sc (general) degree, and academically, B.Sc (Hons) is a more standard degree as compared to B.Sc (general).
If you want to study any one of the purse sciences (eg. chemistry, physics, mathematics etc.) in detail, it is advisable to go for a B.Sc (Hons) course.
But, if you want a more balanced and multi-disciplinary approach, it is better to pursue a B.Sc (General) course for under graduation.

Definitely, NIFT is the best institution for a design course.

You have not specified in which course/stream you wish to pursue the B.Sc (Hons.).

You can work as either of the following after doing B.Sc in physics:
Lab Supervisor
Researcher
Technician
Teacher
Manager
Scientist
Consulting Physicist
Research Associate
Senior Physicist
Assistant Scientist
Radiation Oncologist
Radiologist
Professor

The eligibility depends on the type of course that you wish to pursue, the details of some courses is stated below:
Diploma Class 10th pass from a recognised board with minimum 40% marks.
Bachelors Degree: Class 10+2 examination with at least 50% marks.
Post-graduation degree: Bachelors degree from a recognised university with at least 45% marks.
Graduate & PG programs may also require you to appear in entrance exams such as NCHMCT, AIMA UGAT, E-CHAT etc.

Without pursuing pilot training course, you can't become a pilot.
You have to do both in order to become a good pilot. If you are planning to take Commercial Pilot as a career option then B.Sc Aviation may not directly benefit you except that you will have graduation degree and in long run based on your graduation degree, you can do MBA or any other PG degree.

You are advised to do B.Ed on completion of B.Sc to become a teacher. Once on the job, you may plan higher studies by joining PG degree or Diploma courses by distance learning for career growth and increased employability.