An airport usually goes into LVP's when the cloud base becomes less than 200feet, and visibility less than 600 metres (some use 550).
When LVP's are in force, the airfield lighting and equipment must be up to Cat 3 standards, aircraft separation increases, Cat 2/3/ holds become in use. RVR readouts normally become active below 1500 metres.
Hope this is of some use.