One needs to see breed traits and what best suits ur lifestyle/ how much time you are willing to dedicate towards training, exercise and care.
What you need to see also is what will happen when u r not around or when the family does on vacation. the thought of keeping a pet or dog is great but the responsibility is also what one has to keep in mind.
My suggestion would be first settle down with life in India and with the family in the new surroundings and only after a year or so get a dog/ puppy. At times things dont work out and you may have to shift to Mumbai etc., what then. So first settle down and then get a pet.
I personally would suggest a boxer if you can give it good exercise/ run in the park which is secure and keep it open in the house. They are low maintanance and easier to train and love children, but keep in mind there jumpy and energy levels.
A Rottweiler will need far more time and patience if taking a male, in regard to training etc, but once taken care of properly are a joy for life, but thats with all breeds. For first time Rottweiler owners, a female is always better. The exercise requirements of a Rottweiler are far less and adapt to there surroundings very quickly.
I have had a Rottweilers in the house now for more than 20 odd years and have also got a pet boxer which is 10 odd years.
If you have any specific questions regarding the above mentioned breeds or others, while deciding pls feel free to contact me.