As mentioned, tripods are not usually allowed indoors (museums, churches, etc.), but it is easy to find lockers where you can store them.
The same applies to flash photography, which can damage the pigments in paintings (or so they say).
Outdoors, we use it without worrying too much about city regulations that prohibit it.
Obviously, it is important not to obstruct traffic, including pedestrians.
Obviously, you can carry whatever you want with you (but guns)!
You may be asked to place it in a locker at the museum entrance to prevent you from accidentally breaking any display cases or exhibits.